Release 10.1A: OpenEdge Development:
Debugging and Troubleshooting

Query Info logging

Query Info logging fills a void for 4GL developers trying to evaluate what happens when a query executes and how efficient query execution might be. Poorly indexed queries cause performance degradation. In large deployed applications, it is impractical for developers to add diagnostics to their code to track and analyze the efficiency and performance of queries.

Query Info logging takes advantage of the OpenEdge logging infrastructure to provide 4GL developers with extended logging information to help them uncover poorly performing queries.

The following sections describe:

Understanding Query Info logging
Query Info log entry types and logging levels
Starting Query Info logging
Generating Query Info
Query information logged
Query plan
Query statistics
Sample Query Info logs